﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SysLogDBDataSet1" targetNamespace="http://tempuri.org/SysLogDBDataSet1.xsd" xmlns:mstns="http://tempuri.org/SysLogDBDataSet1.xsd" xmlns="http://tempuri.org/SysLogDBDataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SysLogDBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SysLogDBConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SysLogQuery.Properties.Settings.GlobalReference.Default.SysLogDBConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Logs_vTableAdapter" GeneratorDataComponentClassName="Logs_vTableAdapter" Name="Logs_v" UserDataComponentName="Logs_vTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SysLogDBConnectionString (Settings)" DbObjectName="SysLogDB.dbo.Logs_v" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT recordnumber, timestamp, sourceip, sourcename, Severity, Facility, version, hostname, appname, procid, msgid, msgtimestamp, msgoffset, sdid, msg FROM dbo.Logs_v</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="recordnumber" DataSetColumn="recordnumber" />
              <Mapping SourceColumn="timestamp" DataSetColumn="timestamp" />
              <Mapping SourceColumn="sourceip" DataSetColumn="sourceip" />
              <Mapping SourceColumn="sourcename" DataSetColumn="sourcename" />
              <Mapping SourceColumn="Severity" DataSetColumn="Severity" />
              <Mapping SourceColumn="Facility" DataSetColumn="Facility" />
              <Mapping SourceColumn="version" DataSetColumn="version" />
              <Mapping SourceColumn="hostname" DataSetColumn="hostname" />
              <Mapping SourceColumn="appname" DataSetColumn="appname" />
              <Mapping SourceColumn="procid" DataSetColumn="procid" />
              <Mapping SourceColumn="msgid" DataSetColumn="msgid" />
              <Mapping SourceColumn="msgtimestamp" DataSetColumn="msgtimestamp" />
              <Mapping SourceColumn="msgoffset" DataSetColumn="msgoffset" />
              <Mapping SourceColumn="sdid" DataSetColumn="sdid" />
              <Mapping SourceColumn="msg" DataSetColumn="msg" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SysLogDBConnectionString (Settings)" DbObjectName="SysLogDB.dbo.Logs_v" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Filter" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Filter" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="Filter">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        recordnumber, timestamp, sourceip, sourcename, Severity, Facility, version, hostname, appname, procid, msgid, msgtimestamp, msgoffset, sdid, msg
FROM            Logs_v
WHERE        (sourceip LIKE '%' + rtrim(ltrim(@f_sourceip)) + '%' OR
                         @f_sourceip IS NULL) AND (sourcename LIKE '%' + ltrim(rtrim(@f_sourcename)) + '%' OR
                         @f_sourcename IS NULL) AND (Severity LIKE ltrim(rtrim(@f_Severity)) + N'%' OR
                         @f_Severity IS NULL) AND (Facility LIKE ltrim(rtrim(@f_Facility)) + N'%' OR
                         @f_Facility IS NULL) AND (hostname LIKE '%' + ltrim(rtrim(@f_hostname)) + '%' OR
                         @f_hostname IS NULL) AND (appname LIKE '%' + ltrim(rtrim(@f_appname)) + '%' OR
                         @f_appname IS NULL) AND (msg LIKE '%' + @f_msg + '%' OR
                         @f_msg IS NULL) AND (([timestamp] BETWEEN @f_date1 AND @f_date2) OR
                         @f_date1 IS NULL OR
                         @f_date2 IS NULL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="f_sourceip" ColumnName="sourceip" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="char(10)" DbType="AnsiString" Direction="Input" ParameterName="@f_sourceip" Precision="0" ProviderType="Char" Scale="0" Size="10" SourceColumn="sourceip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="f_sourcename" ColumnName="sourcename" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@f_sourcename" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="sourcename" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_Severity" ColumnName="Severity" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="nvarchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@f_Severity" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="Severity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_Facility" ColumnName="Facility" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="nvarchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@f_Facility" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="Facility" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_hostname" ColumnName="hostname" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@f_hostname" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="hostname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_appname" ColumnName="appname" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="varchar(48)" DbType="AnsiString" Direction="Input" ParameterName="@f_appname" Precision="0" ProviderType="VarChar" Scale="0" Size="48" SourceColumn="appname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_msg" ColumnName="msg" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@f_msg" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="msg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="f_date1" ColumnName="timestamp" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@f_date1" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="timestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="f_date2" ColumnName="timestamp" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@f_date2" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="timestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SysLogDBConnectionString (Settings)" DbObjectName="SysLogDB.dbo.Logs_v" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FilterNewer" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FilterNewer" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FilterNewer">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        recordnumber, timestamp, sourceip, sourcename, Severity, Facility, version, hostname, appname, procid, msgid, msgtimestamp, msgoffset, sdid, msg
FROM            Logs_v
WHERE        (sourceip LIKE '%' + rtrim(ltrim(@f_sourceip)) + '%' OR
                         @f_sourceip IS NULL) AND (sourcename LIKE '%' + ltrim(rtrim(@f_sourcename)) + '%' OR
                         @f_sourcename IS NULL) AND (Severity LIKE ltrim(rtrim(@f_Severity)) + N'%' OR
                         @f_Severity IS NULL) AND (Facility LIKE ltrim(rtrim(@f_Facility)) + N'%' OR
                         @f_Facility IS NULL) AND (hostname LIKE '%' + ltrim(rtrim(@f_hostname)) + '%' OR
                         @f_hostname IS NULL) AND (appname LIKE '%' + ltrim(rtrim(@f_appname)) + '%' OR
                         @f_appname IS NULL) AND (msg LIKE '%' + @f_msg + '%' OR
                         @f_msg IS NULL) AND (([timestamp] &gt; @f_date1 ) OR
                         @f_date1 IS NULL )</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="f_sourceip" ColumnName="sourceip" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="char(10)" DbType="AnsiString" Direction="Input" ParameterName="@f_sourceip" Precision="0" ProviderType="Char" Scale="0" Size="10" SourceColumn="sourceip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="f_sourcename" ColumnName="sourcename" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@f_sourcename" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="sourcename" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_Severity" ColumnName="Severity" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="nvarchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@f_Severity" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="Severity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_Facility" ColumnName="Facility" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="nvarchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@f_Facility" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="Facility" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_hostname" ColumnName="hostname" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@f_hostname" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="hostname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_appname" ColumnName="appname" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="varchar(48)" DbType="AnsiString" Direction="Input" ParameterName="@f_appname" Precision="0" ProviderType="VarChar" Scale="0" Size="48" SourceColumn="appname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_msg" ColumnName="msg" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@f_msg" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="msg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="f_date1" ColumnName="timestamp" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@f_date1" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="timestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SysLogDBConnectionString (Settings)" DbObjectName="SysLogDB.dbo.Logs_v" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Filternodate" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Filternodate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDatanodate" UserSourceName="Filternodate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        recordnumber, timestamp, sourceip, sourcename, Severity, Facility, version, hostname, appname, procid, msgid, msgtimestamp, msgoffset, sdid, msg
FROM            Logs_v
WHERE        (sourceip LIKE '%' + rtrim(ltrim(@f_sourceip)) + '%' OR
                         @f_sourceip IS NULL) AND (sourcename LIKE '%' + ltrim(rtrim(@f_sourcename)) + '%' OR
                         @f_sourcename IS NULL) AND (Severity LIKE ltrim(rtrim(@f_Severity)) + N'%' OR
                         @f_Severity IS NULL) AND (Facility LIKE ltrim(rtrim(@f_Facility)) + N'%' OR
                         @f_Facility IS NULL) AND (hostname LIKE '%' + ltrim(rtrim(@f_hostname)) + '%' OR
                         @f_hostname IS NULL) AND (appname LIKE '%' + ltrim(rtrim(@f_appname)) + '%' OR
                         @f_appname IS NULL) AND (msg LIKE '%' + @f_msg + '%' OR
                         @f_msg IS NULL) </CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="f_sourceip" ColumnName="sourceip" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="char(10)" DbType="AnsiString" Direction="Input" ParameterName="@f_sourceip" Precision="0" ProviderType="Char" Scale="0" Size="10" SourceColumn="sourceip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="f_sourcename" ColumnName="sourcename" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@f_sourcename" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="sourcename" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_Severity" ColumnName="Severity" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="nvarchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@f_Severity" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="Severity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_Facility" ColumnName="Facility" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="nvarchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@f_Facility" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="Facility" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_hostname" ColumnName="hostname" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@f_hostname" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="hostname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_appname" ColumnName="appname" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="varchar(48)" DbType="AnsiString" Direction="Input" ParameterName="@f_appname" Precision="0" ProviderType="VarChar" Scale="0" Size="48" SourceColumn="appname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_msg" ColumnName="msg" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@f_msg" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="msg" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SysLogDBConnectionString (Settings)" DbObjectName="SysLogDB.dbo.Logs_v" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FilterOlder" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FilterOlder" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FilterOlder">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        recordnumber, timestamp, sourceip, sourcename, Severity, Facility, version, hostname, appname, procid, msgid, msgtimestamp, msgoffset, sdid, msg
FROM            Logs_v
WHERE        (sourceip LIKE '%' + rtrim(ltrim(@f_sourceip)) + '%' OR
                         @f_sourceip IS NULL) AND (sourcename LIKE '%' + ltrim(rtrim(@f_sourcename)) + '%' OR
                         @f_sourcename IS NULL) AND (Severity LIKE ltrim(rtrim(@f_Severity)) + N'%' OR
                         @f_Severity IS NULL) AND (Facility LIKE ltrim(rtrim(@f_Facility)) + N'%' OR
                         @f_Facility IS NULL) AND (hostname LIKE '%' + ltrim(rtrim(@f_hostname)) + '%' OR
                         @f_hostname IS NULL) AND (appname LIKE '%' + ltrim(rtrim(@f_appname)) + '%' OR
                         @f_appname IS NULL) AND (msg LIKE '%' + @f_msg + '%' OR
                         @f_msg IS NULL) AND (([timestamp] &lt; @f_date2) OR
                         @f_date2 IS NULL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="f_sourceip" ColumnName="sourceip" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="char(10)" DbType="AnsiString" Direction="Input" ParameterName="@f_sourceip" Precision="0" ProviderType="Char" Scale="0" Size="10" SourceColumn="sourceip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="f_sourcename" ColumnName="sourcename" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@f_sourcename" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="sourcename" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_Severity" ColumnName="Severity" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="nvarchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@f_Severity" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="Severity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_Facility" ColumnName="Facility" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="nvarchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@f_Facility" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="Facility" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_hostname" ColumnName="hostname" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@f_hostname" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="hostname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_appname" ColumnName="appname" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="varchar(48)" DbType="AnsiString" Direction="Input" ParameterName="@f_appname" Precision="0" ProviderType="VarChar" Scale="0" Size="48" SourceColumn="appname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="f_msg" ColumnName="msg" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@f_msg" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="msg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="f_date2" ColumnName="timestamp" DataSourceName="SysLogDB.dbo.Logs_v" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@f_date2" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="timestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SysLogDBDataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="SysLogDBDataSet1" msprop:Generator_UserDSName="SysLogDBDataSet1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Logs_v" msprop:Generator_TableClassName="Logs_vDataTable" msprop:Generator_TableVarName="tableLogs_v" msprop:Generator_RowChangedName="Logs_vRowChanged" msprop:Generator_TablePropName="Logs_v" msprop:Generator_RowDeletingName="Logs_vRowDeleting" msprop:Generator_RowChangingName="Logs_vRowChanging" msprop:Generator_RowEvHandlerName="Logs_vRowChangeEventHandler" msprop:Generator_RowDeletedName="Logs_vRowDeleted" msprop:Generator_RowClassName="Logs_vRow" msprop:Generator_UserTableName="Logs_v" msprop:Generator_RowEvArgName="Logs_vRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="recordnumber" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnrecordnumber" msprop:Generator_ColumnPropNameInRow="recordnumber" msprop:Generator_ColumnPropNameInTable="recordnumberColumn" msprop:Generator_UserColumnName="recordnumber" type="xs:long" />
              <xs:element name="timestamp" msprop:Generator_ColumnVarNameInTable="columntimestamp" msprop:Generator_ColumnPropNameInRow="timestamp" msprop:Generator_ColumnPropNameInTable="timestampColumn" msprop:Generator_UserColumnName="timestamp" type="xs:dateTime" />
              <xs:element name="sourceip" msprop:Generator_ColumnVarNameInTable="columnsourceip" msprop:Generator_ColumnPropNameInRow="sourceip" msprop:Generator_ColumnPropNameInTable="sourceipColumn" msprop:Generator_UserColumnName="sourceip">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sourcename" msprop:Generator_ColumnVarNameInTable="columnsourcename" msprop:Generator_ColumnPropNameInRow="sourcename" msprop:Generator_ColumnPropNameInTable="sourcenameColumn" msprop:Generator_UserColumnName="sourcename">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Severity" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnSeverity" msprop:Generator_ColumnPropNameInRow="Severity" msprop:Generator_ColumnPropNameInTable="SeverityColumn" msprop:Generator_UserColumnName="Severity" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Facility" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnFacility" msprop:Generator_ColumnPropNameInRow="Facility" msprop:Generator_ColumnPropNameInTable="FacilityColumn" msprop:Generator_UserColumnName="Facility" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="version" msprop:Generator_ColumnVarNameInTable="columnversion" msprop:Generator_ColumnPropNameInRow="version" msprop:Generator_ColumnPropNameInTable="versionColumn" msprop:Generator_UserColumnName="version" type="xs:int" minOccurs="0" />
              <xs:element name="hostname" msprop:Generator_ColumnVarNameInTable="columnhostname" msprop:Generator_ColumnPropNameInRow="hostname" msprop:Generator_ColumnPropNameInTable="hostnameColumn" msprop:Generator_UserColumnName="hostname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="appname" msprop:Generator_ColumnVarNameInTable="columnappname" msprop:Generator_ColumnPropNameInRow="appname" msprop:Generator_ColumnPropNameInTable="appnameColumn" msprop:Generator_UserColumnName="appname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="48" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="procid" msprop:Generator_ColumnVarNameInTable="columnprocid" msprop:Generator_ColumnPropNameInRow="procid" msprop:Generator_ColumnPropNameInTable="procidColumn" msprop:Generator_UserColumnName="procid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="msgid" msprop:Generator_ColumnVarNameInTable="columnmsgid" msprop:Generator_ColumnPropNameInRow="msgid" msprop:Generator_ColumnPropNameInTable="msgidColumn" msprop:Generator_UserColumnName="msgid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="msgtimestamp" msprop:Generator_ColumnVarNameInTable="columnmsgtimestamp" msprop:Generator_ColumnPropNameInRow="msgtimestamp" msprop:Generator_ColumnPropNameInTable="msgtimestampColumn" msprop:Generator_UserColumnName="msgtimestamp" type="xs:dateTime" minOccurs="0" />
              <xs:element name="msgoffset" msprop:Generator_ColumnVarNameInTable="columnmsgoffset" msprop:Generator_ColumnPropNameInRow="msgoffset" msprop:Generator_ColumnPropNameInTable="msgoffsetColumn" msprop:Generator_UserColumnName="msgoffset" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sdid" msprop:Generator_ColumnVarNameInTable="columnsdid" msprop:Generator_ColumnPropNameInRow="sdid" msprop:Generator_ColumnPropNameInTable="sdidColumn" msprop:Generator_UserColumnName="sdid" type="xs:long" minOccurs="0" />
              <xs:element name="msg" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmsg" msprop:Generator_ColumnPropNameInRow="msg" msprop:Generator_ColumnPropNameInTable="msgColumn" msprop:Generator_UserColumnName="msg" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Logs_v" />
      <xs:field xpath="mstns:recordnumber" />
    </xs:unique>
  </xs:element>
</xs:schema>